-- CASE 1: T_Const LIKE T_CollateExpr(T_Const)
DROP VIEW BABEL_5608_vu_prepare_t1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t1;
GO

-- CASE 2: T_CollateExpr(T_Const) LIKE T_Const
DROP VIEW BABEL_5608_vu_prepare_t2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t2;
GO

-- CASE 3: T_CollateExpr(T_Const) LIKE T_CollateExpr(T_Const)
DROP VIEW BABEL_5608_vu_prepare_t3_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t3;
GO

-- CASE 4: T_ReLabelType (T_Var) LIKE T_Const
DROP VIEW BABEL_5608_vu_prepare_t4_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t4_1;
GO

DROP VIEW BABEL_5608_vu_prepare_t4_2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t4_2;
GO

-- CASE 5: T_ReLabelType(T_Var) LIKE T_CollateExpr(T_Const)
DROP VIEW BABEL_5608_vu_prepare_t5_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t5_1;
GO

DROP VIEW BABEL_5608_vu_prepare_t5_2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t5_2;
GO

-- CASE 6: T_ReLabelType(T_Var) LIKE T_ReLabelType(T_Var)
DROP VIEW BABEL_5608_vu_prepare_t6_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t6;
GO

-- CASE 7: T_CollateExpr(T_ReLabel(T_Var)) LIKE T_Const
DROP VIEW BABEL_5608_vu_prepare_t7_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t7_1;
GO

DROP VIEW BABEL_5608_vu_prepare_t7_2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t7_2;
GO

-- CASE 8: T_CollateExpr(T_ReLabel(T_Var)) LIKE T_CollateExpr(T_Const)
DROP VIEW BABEL_5608_vu_prepare_t8_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t8_1;
GO

DROP VIEW BABEL_5608_vu_prepare_t8_2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t8_2;
GO

-- CASE 9: T_FuncExpr LIKE T_CollateExpr(T_Const) AND COMBINATIONS
DROP VIEW BABEL_5608_vu_prepare_t9_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_1;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_2_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_2;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_3_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_3;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_4_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_4;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_5_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_5;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_6_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_6;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_7_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_7;
GO

DROP VIEW BABEL_5608_vu_prepare_t9_8_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t9_8;
GO

-- CASE 10: ESCAPE WITH LIKE
DROP VIEW BABEL_5608_vu_prepare_t10_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t10;
GO

-- CASE 11: T_CoerceViaIO
DROP VIEW BABEL_5608_vu_prepare_t11_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t11;
GO

-- CASE 12: CFL CONDITIONS AND MORE
-- IF ELSE
DROP VIEW BABEL_5608_vu_prepare_t12_1_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t12_1;
GO

-- CASE WHEN
DROP VIEW BABEL_5608_vu_prepare_t12_2_VIEW;
GO

-- COMPUTED COLUMN (BABEL-5022)
-- DROP VIEW BABEL_5608_vu_prepare_t12_3_VIEW;
-- GO

-- DROP TABLE BABEL_5608_vu_prepare_t12_3;
-- GO

-- FUNCTIONS
DROP FUNCTION BABEL_5608_vu_prepare_t12_fun1;
GO

-- PROCEDURE
DROP PROCEDURE BABEL_5608_vu_prepare_t12_proc1;
GO

-- CASE 13: VIEW WITH LIKE
DROP VIEW BABEL_5608_13_1_VIEW;
GO

DROP VIEW BABEL_5608_13_2_VIEW;
GO

DROP VIEW BABEL_5608_13_3_VIEW;
GO

DROP VIEW BABEL_5608_13_4_VIEW;
GO

DROP VIEW BABEL_5608_13_5_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t12_2;
GO

-- CASE 14: PostFix Pattern match
DROP VIEW BABEL_5608_vu_prepare_t14_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t14;
GO

-- CASE 15: T_Const LIKE T_Const
DROP VIEW BABEL_5608_vu_prepare_t15_VIEW;
GO

DROP TABLE BABEL_5608_vu_prepare_t15;
GO
